package com.hzhr.extdevice.model.database.device;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;



public class DevCollectDeviceExample
{
    protected String orderByClause;
    protected boolean distinct;
    protected List<Criteria> oredCriteria;

    public DevCollectDeviceExample() { this.oredCriteria = new ArrayList(); }



    public void setOrderByClause(String orderByClause) { this.orderByClause = orderByClause; }



    public String getOrderByClause() { return this.orderByClause; }



    public void setDistinct(boolean distinct) { this.distinct = distinct; }



    public boolean isDistinct() { return this.distinct; }



    public List<Criteria> getOredCriteria() { return this.oredCriteria; }



    public void or(Criteria criteria) { this.oredCriteria.add(criteria); }


    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        this.oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (this.oredCriteria.size() == 0) {
            this.oredCriteria.add(criteria);
        }
        return criteria;
    }


    protected Criteria createCriteriaInternal() { return new Criteria(); }



    public void clear() {
        this.oredCriteria.clear();
        this.orderByClause = null;
        this.distinct = false;
    }


    protected static abstract class GeneratedCriteria
    {
        protected List<DevCollectDeviceExample.Criterion> criteria;

        protected GeneratedCriteria() { this.criteria = new ArrayList(); }



        public boolean isValid() { return (this.criteria.size() > 0); }



        public List<DevCollectDeviceExample.Criterion> getAllCriteria() { return this.criteria; }



        public List<DevCollectDeviceExample.Criterion> getCriteria() { return this.criteria; }


        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            this.criteria.add(new DevCollectDeviceExample.Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            this.criteria.add(new DevCollectDeviceExample.Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            this.criteria.add(new DevCollectDeviceExample.Criterion(condition, value1, value2));
        }

        public DevCollectDeviceExample.Criteria andIdIsNull() {
            addCriterion("ID is null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andIdIsNotNull() {
            addCriterion("ID is not null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andIdEqualTo(Integer value) {
            addCriterion("ID =", value, "id");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andIdNotEqualTo(Integer value) {
            addCriterion("ID <>", value, "id");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andIdGreaterThan(Integer value) {
            addCriterion("ID >", value, "id");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("ID >=", value, "id");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andIdLessThan(Integer value) {
            addCriterion("ID <", value, "id");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("ID <=", value, "id");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andIdIn(List<Integer> values) {
            addCriterion("ID in", values, "id");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andIdNotIn(List<Integer> values) {
            addCriterion("ID not in", values, "id");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("ID between", value1, value2, "id");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("ID not between", value1, value2, "id");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andOutIdIsNull() {
            addCriterion("OUT_ID is null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andOutIdIsNotNull() {
            addCriterion("OUT_ID is not null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andOutIdEqualTo(String value) {
            addCriterion("OUT_ID =", value, "outId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andOutIdNotEqualTo(String value) {
            addCriterion("OUT_ID <>", value, "outId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andOutIdGreaterThan(String value) {
            addCriterion("OUT_ID >", value, "outId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andOutIdGreaterThanOrEqualTo(String value) {
            addCriterion("OUT_ID >=", value, "outId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andOutIdLessThan(String value) {
            addCriterion("OUT_ID <", value, "outId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andOutIdLessThanOrEqualTo(String value) {
            addCriterion("OUT_ID <=", value, "outId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andOutIdLike(String value) {
            addCriterion("OUT_ID like", value, "outId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andOutIdNotLike(String value) {
            addCriterion("OUT_ID not like", value, "outId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andOutIdIn(List<String> values) {
            addCriterion("OUT_ID in", values, "outId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andOutIdNotIn(List<String> values) {
            addCriterion("OUT_ID not in", values, "outId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andOutIdBetween(String value1, String value2) {
            addCriterion("OUT_ID between", value1, value2, "outId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andOutIdNotBetween(String value1, String value2) {
            addCriterion("OUT_ID not between", value1, value2, "outId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCodeIsNull() {
            addCriterion("CODE is null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCodeIsNotNull() {
            addCriterion("CODE is not null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCodeEqualTo(String value) {
            addCriterion("CODE =", value, "code");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCodeNotEqualTo(String value) {
            addCriterion("CODE <>", value, "code");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCodeGreaterThan(String value) {
            addCriterion("CODE >", value, "code");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCodeGreaterThanOrEqualTo(String value) {
            addCriterion("CODE >=", value, "code");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCodeLessThan(String value) {
            addCriterion("CODE <", value, "code");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCodeLessThanOrEqualTo(String value) {
            addCriterion("CODE <=", value, "code");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCodeLike(String value) {
            addCriterion("CODE like", value, "code");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCodeNotLike(String value) {
            addCriterion("CODE not like", value, "code");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCodeIn(List<String> values) {
            addCriterion("CODE in", values, "code");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCodeNotIn(List<String> values) {
            addCriterion("CODE not in", values, "code");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCodeBetween(String value1, String value2) {
            addCriterion("CODE between", value1, value2, "code");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCodeNotBetween(String value1, String value2) {
            addCriterion("CODE not between", value1, value2, "code");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDesIsNull() {
            addCriterion("DES is null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDesIsNotNull() {
            addCriterion("DES is not null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDesEqualTo(String value) {
            addCriterion("DES =", value, "des");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDesNotEqualTo(String value) {
            addCriterion("DES <>", value, "des");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDesGreaterThan(String value) {
            addCriterion("DES >", value, "des");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDesGreaterThanOrEqualTo(String value) {
            addCriterion("DES >=", value, "des");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDesLessThan(String value) {
            addCriterion("DES <", value, "des");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDesLessThanOrEqualTo(String value) {
            addCriterion("DES <=", value, "des");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDesLike(String value) {
            addCriterion("DES like", value, "des");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDesNotLike(String value) {
            addCriterion("DES not like", value, "des");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDesIn(List<String> values) {
            addCriterion("DES in", values, "des");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDesNotIn(List<String> values) {
            addCriterion("DES not in", values, "des");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDesBetween(String value1, String value2) {
            addCriterion("DES between", value1, value2, "des");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDesNotBetween(String value1, String value2) {
            addCriterion("DES not between", value1, value2, "des");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCategoryCodeIsNull() {
            addCriterion("CATEGORY_CODE is null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCategoryCodeIsNotNull() {
            addCriterion("CATEGORY_CODE is not null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCategoryCodeEqualTo(String value) {
            addCriterion("CATEGORY_CODE =", value, "categoryCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCategoryCodeNotEqualTo(String value) {
            addCriterion("CATEGORY_CODE <>", value, "categoryCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCategoryCodeGreaterThan(String value) {
            addCriterion("CATEGORY_CODE >", value, "categoryCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCategoryCodeGreaterThanOrEqualTo(String value) {
            addCriterion("CATEGORY_CODE >=", value, "categoryCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCategoryCodeLessThan(String value) {
            addCriterion("CATEGORY_CODE <", value, "categoryCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCategoryCodeLessThanOrEqualTo(String value) {
            addCriterion("CATEGORY_CODE <=", value, "categoryCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCategoryCodeLike(String value) {
            addCriterion("CATEGORY_CODE like", value, "categoryCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCategoryCodeNotLike(String value) {
            addCriterion("CATEGORY_CODE not like", value, "categoryCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCategoryCodeIn(List<String> values) {
            addCriterion("CATEGORY_CODE in", values, "categoryCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCategoryCodeNotIn(List<String> values) {
            addCriterion("CATEGORY_CODE not in", values, "categoryCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCategoryCodeBetween(String value1, String value2) {
            addCriterion("CATEGORY_CODE between", value1, value2, "categoryCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCategoryCodeNotBetween(String value1, String value2) {
            addCriterion("CATEGORY_CODE not between", value1, value2, "categoryCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andTypeIdIsNull() {
            addCriterion("TYPE_ID is null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andTypeIdIsNotNull() {
            addCriterion("TYPE_ID is not null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andTypeIdEqualTo(Integer value) {
            addCriterion("TYPE_ID =", value, "typeId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andTypeIdNotEqualTo(Integer value) {
            addCriterion("TYPE_ID <>", value, "typeId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andTypeIdGreaterThan(Integer value) {
            addCriterion("TYPE_ID >", value, "typeId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andTypeIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("TYPE_ID >=", value, "typeId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andTypeIdLessThan(Integer value) {
            addCriterion("TYPE_ID <", value, "typeId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andTypeIdLessThanOrEqualTo(Integer value) {
            addCriterion("TYPE_ID <=", value, "typeId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andTypeIdIn(List<Integer> values) {
            addCriterion("TYPE_ID in", values, "typeId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andTypeIdNotIn(List<Integer> values) {
            addCriterion("TYPE_ID not in", values, "typeId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andTypeIdBetween(Integer value1, Integer value2) {
            addCriterion("TYPE_ID between", value1, value2, "typeId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andTypeIdNotBetween(Integer value1, Integer value2) {
            addCriterion("TYPE_ID not between", value1, value2, "typeId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCompanyIdIsNull() {
            addCriterion("COMPANY_ID is null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCompanyIdIsNotNull() {
            addCriterion("COMPANY_ID is not null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCompanyIdEqualTo(Integer value) {
            addCriterion("COMPANY_ID =", value, "companyId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCompanyIdNotEqualTo(Integer value) {
            addCriterion("COMPANY_ID <>", value, "companyId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCompanyIdGreaterThan(Integer value) {
            addCriterion("COMPANY_ID >", value, "companyId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCompanyIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("COMPANY_ID >=", value, "companyId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCompanyIdLessThan(Integer value) {
            addCriterion("COMPANY_ID <", value, "companyId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCompanyIdLessThanOrEqualTo(Integer value) {
            addCriterion("COMPANY_ID <=", value, "companyId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCompanyIdIn(List<Integer> values) {
            addCriterion("COMPANY_ID in", values, "companyId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCompanyIdNotIn(List<Integer> values) {
            addCriterion("COMPANY_ID not in", values, "companyId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCompanyIdBetween(Integer value1, Integer value2) {
            addCriterion("COMPANY_ID between", value1, value2, "companyId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCompanyIdNotBetween(Integer value1, Integer value2) {
            addCriterion("COMPANY_ID not between", value1, value2, "companyId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDeptIdIsNull() {
            addCriterion("DEPT_ID is null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDeptIdIsNotNull() {
            addCriterion("DEPT_ID is not null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDeptIdEqualTo(Integer value) {
            addCriterion("DEPT_ID =", value, "deptId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDeptIdNotEqualTo(Integer value) {
            addCriterion("DEPT_ID <>", value, "deptId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDeptIdGreaterThan(Integer value) {
            addCriterion("DEPT_ID >", value, "deptId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDeptIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("DEPT_ID >=", value, "deptId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDeptIdLessThan(Integer value) {
            addCriterion("DEPT_ID <", value, "deptId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDeptIdLessThanOrEqualTo(Integer value) {
            addCriterion("DEPT_ID <=", value, "deptId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDeptIdIn(List<Integer> values) {
            addCriterion("DEPT_ID in", values, "deptId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDeptIdNotIn(List<Integer> values) {
            addCriterion("DEPT_ID not in", values, "deptId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDeptIdBetween(Integer value1, Integer value2) {
            addCriterion("DEPT_ID between", value1, value2, "deptId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDeptIdNotBetween(Integer value1, Integer value2) {
            addCriterion("DEPT_ID not between", value1, value2, "deptId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDeptCodeIsNull() {
            addCriterion("DEPT_CODE is null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDeptCodeIsNotNull() {
            addCriterion("DEPT_CODE is not null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDeptCodeEqualTo(String value) {
            addCriterion("DEPT_CODE =", value, "deptCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDeptCodeNotEqualTo(String value) {
            addCriterion("DEPT_CODE <>", value, "deptCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDeptCodeGreaterThan(String value) {
            addCriterion("DEPT_CODE >", value, "deptCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDeptCodeGreaterThanOrEqualTo(String value) {
            addCriterion("DEPT_CODE >=", value, "deptCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDeptCodeLessThan(String value) {
            addCriterion("DEPT_CODE <", value, "deptCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDeptCodeLessThanOrEqualTo(String value) {
            addCriterion("DEPT_CODE <=", value, "deptCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDeptCodeLike(String value) {
            addCriterion("DEPT_CODE like", value, "deptCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDeptCodeNotLike(String value) {
            addCriterion("DEPT_CODE not like", value, "deptCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDeptCodeIn(List<String> values) {
            addCriterion("DEPT_CODE in", values, "deptCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDeptCodeNotIn(List<String> values) {
            addCriterion("DEPT_CODE not in", values, "deptCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDeptCodeBetween(String value1, String value2) {
            addCriterion("DEPT_CODE between", value1, value2, "deptCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andDeptCodeNotBetween(String value1, String value2) {
            addCriterion("DEPT_CODE not between", value1, value2, "deptCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserIdIsNull() {
            addCriterion("GAS_USER_ID is null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserIdIsNotNull() {
            addCriterion("GAS_USER_ID is not null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserIdEqualTo(Integer value) {
            addCriterion("GAS_USER_ID =", value, "gasUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserIdNotEqualTo(Integer value) {
            addCriterion("GAS_USER_ID <>", value, "gasUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserIdGreaterThan(Integer value) {
            addCriterion("GAS_USER_ID >", value, "gasUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("GAS_USER_ID >=", value, "gasUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserIdLessThan(Integer value) {
            addCriterion("GAS_USER_ID <", value, "gasUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserIdLessThanOrEqualTo(Integer value) {
            addCriterion("GAS_USER_ID <=", value, "gasUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserIdIn(List<Integer> values) {
            addCriterion("GAS_USER_ID in", values, "gasUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserIdNotIn(List<Integer> values) {
            addCriterion("GAS_USER_ID not in", values, "gasUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserIdBetween(Integer value1, Integer value2) {
            addCriterion("GAS_USER_ID between", value1, value2, "gasUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserIdNotBetween(Integer value1, Integer value2) {
            addCriterion("GAS_USER_ID not between", value1, value2, "gasUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserCodeIsNull() {
            addCriterion("GAS_USER_CODE is null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserCodeIsNotNull() {
            addCriterion("GAS_USER_CODE is not null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserCodeEqualTo(String value) {
            addCriterion("GAS_USER_CODE =", value, "gasUserCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserCodeNotEqualTo(String value) {
            addCriterion("GAS_USER_CODE <>", value, "gasUserCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserCodeGreaterThan(String value) {
            addCriterion("GAS_USER_CODE >", value, "gasUserCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserCodeGreaterThanOrEqualTo(String value) {
            addCriterion("GAS_USER_CODE >=", value, "gasUserCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserCodeLessThan(String value) {
            addCriterion("GAS_USER_CODE <", value, "gasUserCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserCodeLessThanOrEqualTo(String value) {
            addCriterion("GAS_USER_CODE <=", value, "gasUserCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserCodeLike(String value) {
            addCriterion("GAS_USER_CODE like", value, "gasUserCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserCodeNotLike(String value) {
            addCriterion("GAS_USER_CODE not like", value, "gasUserCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserCodeIn(List<String> values) {
            addCriterion("GAS_USER_CODE in", values, "gasUserCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserCodeNotIn(List<String> values) {
            addCriterion("GAS_USER_CODE not in", values, "gasUserCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserCodeBetween(String value1, String value2) {
            addCriterion("GAS_USER_CODE between", value1, value2, "gasUserCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserCodeNotBetween(String value1, String value2) {
            addCriterion("GAS_USER_CODE not between", value1, value2, "gasUserCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserNameIsNull() {
            addCriterion("GAS_USER_NAME is null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserNameIsNotNull() {
            addCriterion("GAS_USER_NAME is not null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserNameEqualTo(String value) {
            addCriterion("GAS_USER_NAME =", value, "gasUserName");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserNameNotEqualTo(String value) {
            addCriterion("GAS_USER_NAME <>", value, "gasUserName");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserNameGreaterThan(String value) {
            addCriterion("GAS_USER_NAME >", value, "gasUserName");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserNameGreaterThanOrEqualTo(String value) {
            addCriterion("GAS_USER_NAME >=", value, "gasUserName");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserNameLessThan(String value) {
            addCriterion("GAS_USER_NAME <", value, "gasUserName");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserNameLessThanOrEqualTo(String value) {
            addCriterion("GAS_USER_NAME <=", value, "gasUserName");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserNameLike(String value) {
            addCriterion("GAS_USER_NAME like", value, "gasUserName");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserNameNotLike(String value) {
            addCriterion("GAS_USER_NAME not like", value, "gasUserName");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserNameIn(List<String> values) {
            addCriterion("GAS_USER_NAME in", values, "gasUserName");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserNameNotIn(List<String> values) {
            addCriterion("GAS_USER_NAME not in", values, "gasUserName");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserNameBetween(String value1, String value2) {
            addCriterion("GAS_USER_NAME between", value1, value2, "gasUserName");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserNameNotBetween(String value1, String value2) {
            addCriterion("GAS_USER_NAME not between", value1, value2, "gasUserName");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserAddressIsNull() {
            addCriterion("GAS_USER_ADDRESS is null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserAddressIsNotNull() {
            addCriterion("GAS_USER_ADDRESS is not null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserAddressEqualTo(String value) {
            addCriterion("GAS_USER_ADDRESS =", value, "gasUserAddress");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserAddressNotEqualTo(String value) {
            addCriterion("GAS_USER_ADDRESS <>", value, "gasUserAddress");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserAddressGreaterThan(String value) {
            addCriterion("GAS_USER_ADDRESS >", value, "gasUserAddress");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserAddressGreaterThanOrEqualTo(String value) {
            addCriterion("GAS_USER_ADDRESS >=", value, "gasUserAddress");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserAddressLessThan(String value) {
            addCriterion("GAS_USER_ADDRESS <", value, "gasUserAddress");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserAddressLessThanOrEqualTo(String value) {
            addCriterion("GAS_USER_ADDRESS <=", value, "gasUserAddress");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserAddressLike(String value) {
            addCriterion("GAS_USER_ADDRESS like", value, "gasUserAddress");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserAddressNotLike(String value) {
            addCriterion("GAS_USER_ADDRESS not like", value, "gasUserAddress");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserAddressIn(List<String> values) {
            addCriterion("GAS_USER_ADDRESS in", values, "gasUserAddress");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserAddressNotIn(List<String> values) {
            addCriterion("GAS_USER_ADDRESS not in", values, "gasUserAddress");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserAddressBetween(String value1, String value2) {
            addCriterion("GAS_USER_ADDRESS between", value1, value2, "gasUserAddress");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andGasUserAddressNotBetween(String value1, String value2) {
            addCriterion("GAS_USER_ADDRESS not between", value1, value2, "gasUserAddress");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andInstallAddressIsNull() {
            addCriterion("INSTALL_ADDRESS is null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andInstallAddressIsNotNull() {
            addCriterion("INSTALL_ADDRESS is not null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andInstallAddressEqualTo(String value) {
            addCriterion("INSTALL_ADDRESS =", value, "installAddress");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andInstallAddressNotEqualTo(String value) {
            addCriterion("INSTALL_ADDRESS <>", value, "installAddress");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andInstallAddressGreaterThan(String value) {
            addCriterion("INSTALL_ADDRESS >", value, "installAddress");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andInstallAddressGreaterThanOrEqualTo(String value) {
            addCriterion("INSTALL_ADDRESS >=", value, "installAddress");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andInstallAddressLessThan(String value) {
            addCriterion("INSTALL_ADDRESS <", value, "installAddress");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andInstallAddressLessThanOrEqualTo(String value) {
            addCriterion("INSTALL_ADDRESS <=", value, "installAddress");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andInstallAddressLike(String value) {
            addCriterion("INSTALL_ADDRESS like", value, "installAddress");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andInstallAddressNotLike(String value) {
            addCriterion("INSTALL_ADDRESS not like", value, "installAddress");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andInstallAddressIn(List<String> values) {
            addCriterion("INSTALL_ADDRESS in", values, "installAddress");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andInstallAddressNotIn(List<String> values) {
            addCriterion("INSTALL_ADDRESS not in", values, "installAddress");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andInstallAddressBetween(String value1, String value2) {
            addCriterion("INSTALL_ADDRESS between", value1, value2, "installAddress");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andInstallAddressNotBetween(String value1, String value2) {
            addCriterion("INSTALL_ADDRESS not between", value1, value2, "installAddress");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andIotDeviceIdIsNull() {
            addCriterion("IOT_DEVICE_ID is null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andIotDeviceIdIsNotNull() {
            addCriterion("IOT_DEVICE_ID is not null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andIotDeviceIdEqualTo(Integer value) {
            addCriterion("IOT_DEVICE_ID =", value, "iotDeviceId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andIotDeviceIdNotEqualTo(Integer value) {
            addCriterion("IOT_DEVICE_ID <>", value, "iotDeviceId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andIotDeviceIdGreaterThan(Integer value) {
            addCriterion("IOT_DEVICE_ID >", value, "iotDeviceId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andIotDeviceIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("IOT_DEVICE_ID >=", value, "iotDeviceId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andIotDeviceIdLessThan(Integer value) {
            addCriterion("IOT_DEVICE_ID <", value, "iotDeviceId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andIotDeviceIdLessThanOrEqualTo(Integer value) {
            addCriterion("IOT_DEVICE_ID <=", value, "iotDeviceId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andIotDeviceIdIn(List<Integer> values) {
            addCriterion("IOT_DEVICE_ID in", values, "iotDeviceId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andIotDeviceIdNotIn(List<Integer> values) {
            addCriterion("IOT_DEVICE_ID not in", values, "iotDeviceId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andIotDeviceIdBetween(Integer value1, Integer value2) {
            addCriterion("IOT_DEVICE_ID between", value1, value2, "iotDeviceId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andIotDeviceIdNotBetween(Integer value1, Integer value2) {
            addCriterion("IOT_DEVICE_ID not between", value1, value2, "iotDeviceId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andPressureUnitIsNull() {
            addCriterion("PRESSURE_UNIT is null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andPressureUnitIsNotNull() {
            addCriterion("PRESSURE_UNIT is not null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andPressureUnitEqualTo(String value) {
            addCriterion("PRESSURE_UNIT =", value, "pressureUnit");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andPressureUnitNotEqualTo(String value) {
            addCriterion("PRESSURE_UNIT <>", value, "pressureUnit");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andPressureUnitGreaterThan(String value) {
            addCriterion("PRESSURE_UNIT >", value, "pressureUnit");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andPressureUnitGreaterThanOrEqualTo(String value) {
            addCriterion("PRESSURE_UNIT >=", value, "pressureUnit");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andPressureUnitLessThan(String value) {
            addCriterion("PRESSURE_UNIT <", value, "pressureUnit");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andPressureUnitLessThanOrEqualTo(String value) {
            addCriterion("PRESSURE_UNIT <=", value, "pressureUnit");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andPressureUnitLike(String value) {
            addCriterion("PRESSURE_UNIT like", value, "pressureUnit");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andPressureUnitNotLike(String value) {
            addCriterion("PRESSURE_UNIT not like", value, "pressureUnit");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andPressureUnitIn(List<String> values) {
            addCriterion("PRESSURE_UNIT in", values, "pressureUnit");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andPressureUnitNotIn(List<String> values) {
            addCriterion("PRESSURE_UNIT not in", values, "pressureUnit");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andPressureUnitBetween(String value1, String value2) {
            addCriterion("PRESSURE_UNIT between", value1, value2, "pressureUnit");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andPressureUnitNotBetween(String value1, String value2) {
            addCriterion("PRESSURE_UNIT not between", value1, value2, "pressureUnit");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCurrentReadingIsNull() {
            addCriterion("CURRENT_READING is null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCurrentReadingIsNotNull() {
            addCriterion("CURRENT_READING is not null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCurrentReadingEqualTo(Double value) {
            addCriterion("CURRENT_READING =", value, "currentReading");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCurrentReadingNotEqualTo(Double value) {
            addCriterion("CURRENT_READING <>", value, "currentReading");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCurrentReadingGreaterThan(Double value) {
            addCriterion("CURRENT_READING >", value, "currentReading");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCurrentReadingGreaterThanOrEqualTo(Double value) {
            addCriterion("CURRENT_READING >=", value, "currentReading");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCurrentReadingLessThan(Double value) {
            addCriterion("CURRENT_READING <", value, "currentReading");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCurrentReadingLessThanOrEqualTo(Double value) {
            addCriterion("CURRENT_READING <=", value, "currentReading");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCurrentReadingIn(List<Double> values) {
            addCriterion("CURRENT_READING in", values, "currentReading");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCurrentReadingNotIn(List<Double> values) {
            addCriterion("CURRENT_READING not in", values, "currentReading");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCurrentReadingBetween(Double value1, Double value2) {
            addCriterion("CURRENT_READING between", value1, value2, "currentReading");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCurrentReadingNotBetween(Double value1, Double value2) {
            addCriterion("CURRENT_READING not between", value1, value2, "currentReading");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCurrentValveStatusCodeIsNull() {
            addCriterion("CURRENT_VALVE_STATUS_CODE is null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCurrentValveStatusCodeIsNotNull() {
            addCriterion("CURRENT_VALVE_STATUS_CODE is not null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCurrentValveStatusCodeEqualTo(String value) {
            addCriterion("CURRENT_VALVE_STATUS_CODE =", value, "currentValveStatusCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCurrentValveStatusCodeNotEqualTo(String value) {
            addCriterion("CURRENT_VALVE_STATUS_CODE <>", value, "currentValveStatusCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCurrentValveStatusCodeGreaterThan(String value) {
            addCriterion("CURRENT_VALVE_STATUS_CODE >", value, "currentValveStatusCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCurrentValveStatusCodeGreaterThanOrEqualTo(String value) {
            addCriterion("CURRENT_VALVE_STATUS_CODE >=", value, "currentValveStatusCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCurrentValveStatusCodeLessThan(String value) {
            addCriterion("CURRENT_VALVE_STATUS_CODE <", value, "currentValveStatusCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCurrentValveStatusCodeLessThanOrEqualTo(String value) {
            addCriterion("CURRENT_VALVE_STATUS_CODE <=", value, "currentValveStatusCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCurrentValveStatusCodeLike(String value) {
            addCriterion("CURRENT_VALVE_STATUS_CODE like", value, "currentValveStatusCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCurrentValveStatusCodeNotLike(String value) {
            addCriterion("CURRENT_VALVE_STATUS_CODE not like", value, "currentValveStatusCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCurrentValveStatusCodeIn(List<String> values) {
            addCriterion("CURRENT_VALVE_STATUS_CODE in", values, "currentValveStatusCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCurrentValveStatusCodeNotIn(List<String> values) {
            addCriterion("CURRENT_VALVE_STATUS_CODE not in", values, "currentValveStatusCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCurrentValveStatusCodeBetween(String value1, String value2) {
            addCriterion("CURRENT_VALVE_STATUS_CODE between", value1, value2, "currentValveStatusCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCurrentValveStatusCodeNotBetween(String value1, String value2) {
            addCriterion("CURRENT_VALVE_STATUS_CODE not between", value1, value2, "currentValveStatusCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCurrentCellVoltageIsNull() {
            addCriterion("CURRENT_CELL_VOLTAGE is null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCurrentCellVoltageIsNotNull() {
            addCriterion("CURRENT_CELL_VOLTAGE is not null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCurrentCellVoltageEqualTo(Float value) {
            addCriterion("CURRENT_CELL_VOLTAGE =", value, "currentCellVoltage");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCurrentCellVoltageNotEqualTo(Float value) {
            addCriterion("CURRENT_CELL_VOLTAGE <>", value, "currentCellVoltage");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCurrentCellVoltageGreaterThan(Float value) {
            addCriterion("CURRENT_CELL_VOLTAGE >", value, "currentCellVoltage");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCurrentCellVoltageGreaterThanOrEqualTo(Float value) {
            addCriterion("CURRENT_CELL_VOLTAGE >=", value, "currentCellVoltage");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCurrentCellVoltageLessThan(Float value) {
            addCriterion("CURRENT_CELL_VOLTAGE <", value, "currentCellVoltage");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCurrentCellVoltageLessThanOrEqualTo(Float value) {
            addCriterion("CURRENT_CELL_VOLTAGE <=", value, "currentCellVoltage");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCurrentCellVoltageIn(List<Float> values) {
            addCriterion("CURRENT_CELL_VOLTAGE in", values, "currentCellVoltage");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCurrentCellVoltageNotIn(List<Float> values) {
            addCriterion("CURRENT_CELL_VOLTAGE not in", values, "currentCellVoltage");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCurrentCellVoltageBetween(Float value1, Float value2) {
            addCriterion("CURRENT_CELL_VOLTAGE between", value1, value2, "currentCellVoltage");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCurrentCellVoltageNotBetween(Float value1, Float value2) {
            addCriterion("CURRENT_CELL_VOLTAGE not between", value1, value2, "currentCellVoltage");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andLastCollectTimeIsNull() {
            addCriterion("LAST_COLLECT_TIME is null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andLastCollectTimeIsNotNull() {
            addCriterion("LAST_COLLECT_TIME is not null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andLastCollectTimeEqualTo(Date value) {
            addCriterion("LAST_COLLECT_TIME =", value, "lastCollectTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andLastCollectTimeNotEqualTo(Date value) {
            addCriterion("LAST_COLLECT_TIME <>", value, "lastCollectTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andLastCollectTimeGreaterThan(Date value) {
            addCriterion("LAST_COLLECT_TIME >", value, "lastCollectTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andLastCollectTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("LAST_COLLECT_TIME >=", value, "lastCollectTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andLastCollectTimeLessThan(Date value) {
            addCriterion("LAST_COLLECT_TIME <", value, "lastCollectTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andLastCollectTimeLessThanOrEqualTo(Date value) {
            addCriterion("LAST_COLLECT_TIME <=", value, "lastCollectTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andLastCollectTimeIn(List<Date> values) {
            addCriterion("LAST_COLLECT_TIME in", values, "lastCollectTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andLastCollectTimeNotIn(List<Date> values) {
            addCriterion("LAST_COLLECT_TIME not in", values, "lastCollectTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andLastCollectTimeBetween(Date value1, Date value2) {
            addCriterion("LAST_COLLECT_TIME between", value1, value2, "lastCollectTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andLastCollectTimeNotBetween(Date value1, Date value2) {
            addCriterion("LAST_COLLECT_TIME not between", value1, value2, "lastCollectTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andUsingDateIsNull() {
            addCriterion("USING_DATE is null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andUsingDateIsNotNull() {
            addCriterion("USING_DATE is not null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andUsingDateEqualTo(Date value) {
            addCriterion("USING_DATE =", value, "usingDate");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andUsingDateNotEqualTo(Date value) {
            addCriterion("USING_DATE <>", value, "usingDate");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andUsingDateGreaterThan(Date value) {
            addCriterion("USING_DATE >", value, "usingDate");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andUsingDateGreaterThanOrEqualTo(Date value) {
            addCriterion("USING_DATE >=", value, "usingDate");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andUsingDateLessThan(Date value) {
            addCriterion("USING_DATE <", value, "usingDate");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andUsingDateLessThanOrEqualTo(Date value) {
            addCriterion("USING_DATE <=", value, "usingDate");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andUsingDateIn(List<Date> values) {
            addCriterion("USING_DATE in", values, "usingDate");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andUsingDateNotIn(List<Date> values) {
            addCriterion("USING_DATE not in", values, "usingDate");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andUsingDateBetween(Date value1, Date value2) {
            addCriterion("USING_DATE between", value1, value2, "usingDate");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andUsingDateNotBetween(Date value1, Date value2) {
            addCriterion("USING_DATE not between", value1, value2, "usingDate");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andManageUserIdIsNull() {
            addCriterion("MANAGE_USER_ID is null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andManageUserIdIsNotNull() {
            addCriterion("MANAGE_USER_ID is not null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andManageUserIdEqualTo(Integer value) {
            addCriterion("MANAGE_USER_ID =", value, "manageUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andManageUserIdNotEqualTo(Integer value) {
            addCriterion("MANAGE_USER_ID <>", value, "manageUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andManageUserIdGreaterThan(Integer value) {
            addCriterion("MANAGE_USER_ID >", value, "manageUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andManageUserIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("MANAGE_USER_ID >=", value, "manageUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andManageUserIdLessThan(Integer value) {
            addCriterion("MANAGE_USER_ID <", value, "manageUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andManageUserIdLessThanOrEqualTo(Integer value) {
            addCriterion("MANAGE_USER_ID <=", value, "manageUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andManageUserIdIn(List<Integer> values) {
            addCriterion("MANAGE_USER_ID in", values, "manageUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andManageUserIdNotIn(List<Integer> values) {
            addCriterion("MANAGE_USER_ID not in", values, "manageUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andManageUserIdBetween(Integer value1, Integer value2) {
            addCriterion("MANAGE_USER_ID between", value1, value2, "manageUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andManageUserIdNotBetween(Integer value1, Integer value2) {
            addCriterion("MANAGE_USER_ID not between", value1, value2, "manageUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andManageUserNameIsNull() {
            addCriterion("MANAGE_USER_NAME is null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andManageUserNameIsNotNull() {
            addCriterion("MANAGE_USER_NAME is not null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andManageUserNameEqualTo(String value) {
            addCriterion("MANAGE_USER_NAME =", value, "manageUserName");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andManageUserNameNotEqualTo(String value) {
            addCriterion("MANAGE_USER_NAME <>", value, "manageUserName");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andManageUserNameGreaterThan(String value) {
            addCriterion("MANAGE_USER_NAME >", value, "manageUserName");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andManageUserNameGreaterThanOrEqualTo(String value) {
            addCriterion("MANAGE_USER_NAME >=", value, "manageUserName");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andManageUserNameLessThan(String value) {
            addCriterion("MANAGE_USER_NAME <", value, "manageUserName");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andManageUserNameLessThanOrEqualTo(String value) {
            addCriterion("MANAGE_USER_NAME <=", value, "manageUserName");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andManageUserNameLike(String value) {
            addCriterion("MANAGE_USER_NAME like", value, "manageUserName");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andManageUserNameNotLike(String value) {
            addCriterion("MANAGE_USER_NAME not like", value, "manageUserName");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andManageUserNameIn(List<String> values) {
            addCriterion("MANAGE_USER_NAME in", values, "manageUserName");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andManageUserNameNotIn(List<String> values) {
            addCriterion("MANAGE_USER_NAME not in", values, "manageUserName");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andManageUserNameBetween(String value1, String value2) {
            addCriterion("MANAGE_USER_NAME between", value1, value2, "manageUserName");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andManageUserNameNotBetween(String value1, String value2) {
            addCriterion("MANAGE_USER_NAME not between", value1, value2, "manageUserName");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andInstallTimeIsNull() {
            addCriterion("INSTALL_TIME is null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andInstallTimeIsNotNull() {
            addCriterion("INSTALL_TIME is not null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andInstallTimeEqualTo(Date value) {
            addCriterion("INSTALL_TIME =", value, "installTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andInstallTimeNotEqualTo(Date value) {
            addCriterion("INSTALL_TIME <>", value, "installTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andInstallTimeGreaterThan(Date value) {
            addCriterion("INSTALL_TIME >", value, "installTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andInstallTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("INSTALL_TIME >=", value, "installTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andInstallTimeLessThan(Date value) {
            addCriterion("INSTALL_TIME <", value, "installTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andInstallTimeLessThanOrEqualTo(Date value) {
            addCriterion("INSTALL_TIME <=", value, "installTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andInstallTimeIn(List<Date> values) {
            addCriterion("INSTALL_TIME in", values, "installTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andInstallTimeNotIn(List<Date> values) {
            addCriterion("INSTALL_TIME not in", values, "installTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andInstallTimeBetween(Date value1, Date value2) {
            addCriterion("INSTALL_TIME between", value1, value2, "installTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andInstallTimeNotBetween(Date value1, Date value2) {
            addCriterion("INSTALL_TIME not between", value1, value2, "installTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCreateTimeIsNull() {
            addCriterion("CREATE_TIME is null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCreateTimeIsNotNull() {
            addCriterion("CREATE_TIME is not null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("CREATE_TIME =", value, "createTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("CREATE_TIME <>", value, "createTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("CREATE_TIME >", value, "createTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("CREATE_TIME >=", value, "createTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCreateTimeLessThan(Date value) {
            addCriterion("CREATE_TIME <", value, "createTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("CREATE_TIME <=", value, "createTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("CREATE_TIME in", values, "createTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("CREATE_TIME not in", values, "createTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("CREATE_TIME between", value1, value2, "createTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("CREATE_TIME not between", value1, value2, "createTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andUpdateTimeIsNull() {
            addCriterion("UPDATE_TIME is null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andUpdateTimeIsNotNull() {
            addCriterion("UPDATE_TIME is not null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("UPDATE_TIME =", value, "updateTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("UPDATE_TIME <>", value, "updateTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("UPDATE_TIME >", value, "updateTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("UPDATE_TIME >=", value, "updateTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("UPDATE_TIME <", value, "updateTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("UPDATE_TIME <=", value, "updateTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("UPDATE_TIME in", values, "updateTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("UPDATE_TIME not in", values, "updateTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("UPDATE_TIME between", value1, value2, "updateTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("UPDATE_TIME not between", value1, value2, "updateTime");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCreateUserIdIsNull() {
            addCriterion("CREATE_USER_ID is null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCreateUserIdIsNotNull() {
            addCriterion("CREATE_USER_ID is not null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCreateUserIdEqualTo(Integer value) {
            addCriterion("CREATE_USER_ID =", value, "createUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCreateUserIdNotEqualTo(Integer value) {
            addCriterion("CREATE_USER_ID <>", value, "createUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCreateUserIdGreaterThan(Integer value) {
            addCriterion("CREATE_USER_ID >", value, "createUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCreateUserIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("CREATE_USER_ID >=", value, "createUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCreateUserIdLessThan(Integer value) {
            addCriterion("CREATE_USER_ID <", value, "createUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCreateUserIdLessThanOrEqualTo(Integer value) {
            addCriterion("CREATE_USER_ID <=", value, "createUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCreateUserIdIn(List<Integer> values) {
            addCriterion("CREATE_USER_ID in", values, "createUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCreateUserIdNotIn(List<Integer> values) {
            addCriterion("CREATE_USER_ID not in", values, "createUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCreateUserIdBetween(Integer value1, Integer value2) {
            addCriterion("CREATE_USER_ID between", value1, value2, "createUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andCreateUserIdNotBetween(Integer value1, Integer value2) {
            addCriterion("CREATE_USER_ID not between", value1, value2, "createUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andUpdateUserIdIsNull() {
            addCriterion("UPDATE_USER_ID is null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andUpdateUserIdIsNotNull() {
            addCriterion("UPDATE_USER_ID is not null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andUpdateUserIdEqualTo(Integer value) {
            addCriterion("UPDATE_USER_ID =", value, "updateUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andUpdateUserIdNotEqualTo(Integer value) {
            addCriterion("UPDATE_USER_ID <>", value, "updateUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andUpdateUserIdGreaterThan(Integer value) {
            addCriterion("UPDATE_USER_ID >", value, "updateUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andUpdateUserIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("UPDATE_USER_ID >=", value, "updateUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andUpdateUserIdLessThan(Integer value) {
            addCriterion("UPDATE_USER_ID <", value, "updateUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andUpdateUserIdLessThanOrEqualTo(Integer value) {
            addCriterion("UPDATE_USER_ID <=", value, "updateUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andUpdateUserIdIn(List<Integer> values) {
            addCriterion("UPDATE_USER_ID in", values, "updateUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andUpdateUserIdNotIn(List<Integer> values) {
            addCriterion("UPDATE_USER_ID not in", values, "updateUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andUpdateUserIdBetween(Integer value1, Integer value2) {
            addCriterion("UPDATE_USER_ID between", value1, value2, "updateUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andUpdateUserIdNotBetween(Integer value1, Integer value2) {
            addCriterion("UPDATE_USER_ID not between", value1, value2, "updateUserId");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andResourceCodeIsNull() {
            addCriterion("RESOURCE_CODE is null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andResourceCodeIsNotNull() {
            addCriterion("RESOURCE_CODE is not null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andResourceCodeEqualTo(String value) {
            addCriterion("RESOURCE_CODE =", value, "resourceCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andResourceCodeNotEqualTo(String value) {
            addCriterion("RESOURCE_CODE <>", value, "resourceCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andResourceCodeGreaterThan(String value) {
            addCriterion("RESOURCE_CODE >", value, "resourceCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andResourceCodeGreaterThanOrEqualTo(String value) {
            addCriterion("RESOURCE_CODE >=", value, "resourceCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andResourceCodeLessThan(String value) {
            addCriterion("RESOURCE_CODE <", value, "resourceCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andResourceCodeLessThanOrEqualTo(String value) {
            addCriterion("RESOURCE_CODE <=", value, "resourceCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andResourceCodeLike(String value) {
            addCriterion("RESOURCE_CODE like", value, "resourceCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andResourceCodeNotLike(String value) {
            addCriterion("RESOURCE_CODE not like", value, "resourceCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andResourceCodeIn(List<String> values) {
            addCriterion("RESOURCE_CODE in", values, "resourceCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andResourceCodeNotIn(List<String> values) {
            addCriterion("RESOURCE_CODE not in", values, "resourceCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andResourceCodeBetween(String value1, String value2) {
            addCriterion("RESOURCE_CODE between", value1, value2, "resourceCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andResourceCodeNotBetween(String value1, String value2) {
            addCriterion("RESOURCE_CODE not between", value1, value2, "resourceCode");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andIsValidIsNull() {
            addCriterion("IS_VALID is null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andIsValidIsNotNull() {
            addCriterion("IS_VALID is not null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andIsValidEqualTo(String value) {
            addCriterion("IS_VALID =", value, "isValid");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andIsValidNotEqualTo(String value) {
            addCriterion("IS_VALID <>", value, "isValid");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andIsValidGreaterThan(String value) {
            addCriterion("IS_VALID >", value, "isValid");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andIsValidGreaterThanOrEqualTo(String value) {
            addCriterion("IS_VALID >=", value, "isValid");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andIsValidLessThan(String value) {
            addCriterion("IS_VALID <", value, "isValid");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andIsValidLessThanOrEqualTo(String value) {
            addCriterion("IS_VALID <=", value, "isValid");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andIsValidLike(String value) {
            addCriterion("IS_VALID like", value, "isValid");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andIsValidNotLike(String value) {
            addCriterion("IS_VALID not like", value, "isValid");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andIsValidIn(List<String> values) {
            addCriterion("IS_VALID in", values, "isValid");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andIsValidNotIn(List<String> values) {
            addCriterion("IS_VALID not in", values, "isValid");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andIsValidBetween(String value1, String value2) {
            addCriterion("IS_VALID between", value1, value2, "isValid");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andIsValidNotBetween(String value1, String value2) {
            addCriterion("IS_VALID not between", value1, value2, "isValid");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andStateIsNull() {
            addCriterion("STATE is null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andStateIsNotNull() {
            addCriterion("STATE is not null");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andStateEqualTo(String value) {
            addCriterion("STATE =", value, "state");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andStateNotEqualTo(String value) {
            addCriterion("STATE <>", value, "state");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andStateGreaterThan(String value) {
            addCriterion("STATE >", value, "state");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andStateGreaterThanOrEqualTo(String value) {
            addCriterion("STATE >=", value, "state");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andStateLessThan(String value) {
            addCriterion("STATE <", value, "state");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andStateLessThanOrEqualTo(String value) {
            addCriterion("STATE <=", value, "state");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andStateLike(String value) {
            addCriterion("STATE like", value, "state");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andStateNotLike(String value) {
            addCriterion("STATE not like", value, "state");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andStateIn(List<String> values) {
            addCriterion("STATE in", values, "state");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andStateNotIn(List<String> values) {
            addCriterion("STATE not in", values, "state");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andStateBetween(String value1, String value2) {
            addCriterion("STATE between", value1, value2, "state");
            return (DevCollectDeviceExample.Criteria)this;
        }

        public DevCollectDeviceExample.Criteria andStateNotBetween(String value1, String value2) {
            addCriterion("STATE not between", value1, value2, "state");
            return (DevCollectDeviceExample.Criteria)this;
        }
    }



    public static class Criteria
            extends GeneratedCriteria {}


    public static class Criterion
    {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;


        public String getCondition() { return this.condition; }



        public Object getValue() { return this.value; }



        public Object getSecondValue() { return this.secondValue; }



        public boolean isNoValue() { return this.noValue; }



        public boolean isSingleValue() { return this.singleValue; }



        public boolean isBetweenValue() { return this.betweenValue; }



        public boolean isListValue() { return this.listValue; }



        public String getTypeHandler() { return this.typeHandler; }



        protected Criterion(String condition) {
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }


        protected Criterion(String condition, Object value, String typeHandler) {
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }


        protected Criterion(String condition, Object value) { this(condition, value, null); }



        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }


        protected Criterion(String condition, Object value, Object secondValue) { this(condition, value, secondValue, null); }
    }
}
